The following table lists ANSI SQL data types, their equivalent Microsoft Jet database engine SQL data types, and their valid synonyms. It also lists the equivalent Microsoft� SQL Server� data types.
ANSI SQL data type |
Microsoft Jet SQL data type |
Synonym |
Microsoft SQL Server data type |
---|---|---|---|
BIT, BIT VARYING | BINARY (See Notes) | VARBINARY, BINARY VARYING BIT VARYING |
BINARY, VARBINARY |
Not supported | BIT (See Notes) | BOOLEAN, LOGICAL, LOGICAL1, YESNO | BIT |
Not supported | TINYINT | INTEGER1, BYTE | TINYINT |
Not supported | COUNTER (See Notes) | AUTOINCREMENT | (See Notes) |
Not supported | MONEY | CURRENCY | MONEY |
DATE, TIME, TIMESTAMP | DATETIME | DATE, TIME (See Notes) | DATETIME |
Not supported | UNIQUEIDENTIFIER | GUID | UNIQUEIDENTIFIER |
DECIMAL | DECIMAL | NUMERIC, DEC | DECIMAL |
REAL | REAL | SINGLE, FLOAT4, IEEESINGLE | REAL |
DOUBLE PRECISION, FLOAT | FLOAT | DOUBLE, FLOAT8, IEEEDOUBLE, NUMBER (See Notes) | FLOAT |
SMALLINT | SMALLINT | SHORT, INTEGER2 | SMALLINT |
INTEGER | INTEGER | LONG, INT, INTEGER4 | INTEGER |
INTERVAL | Not supported | Not supported | |
Not supported | IMAGE | LONGBINARY, GENERAL, OLEOBJECT | IMAGE |
Not supported | TEXT (See Notes) | LONGTEXT, LONGCHAR, MEMO, NOTE, NTEXT (See Notes) | TEXT |
CHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING | CHAR (See Notes) | TEXT(n), ALPHANUMERIC, CHARACTER, STRING, VARCHAR, CHARACTER VARYING, NCHAR, NATIONAL CHARACTER, NATIONAL CHAR, NATIONAL CHARACTER VARYING, NATIONAL CHAR VARYING (See Notes) | CHAR, VARCHAR, NCHAR, NVARCHAR |
Notes
Microsoft Jet Database Engine SQL Data Types